/*
 Navicat Premium Data Transfer

 Source Server         : mysql@localhost-3306
 Source Server Type    : MySQL
 Source Server Version : 80013
 Source Host           : localhost
 Source Database       : db_qa

 Target Server Type    : MySQL
 Target Server Version : 80013
 File Encoding         : utf-8

 Date: 02/27/2022 00:31:39 AM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `t_audit`
-- ----------------------------
DROP TABLE IF EXISTS `t_audit`;
CREATE TABLE `t_audit` (
  `audit_id` int(11) NOT NULL AUTO_INCREMENT,
  `audit_reportUserId` int(11) NOT NULL,
  `audit_postId` int(11) NOT NULL,
  `audit_postUserId` int(11) NOT NULL,
  `audti_result` enum('1','2','3') NOT NULL DEFAULT '1',
  `auditCreate_time` date DEFAULT NULL,
  PRIMARY KEY (`audit_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `t_bank_card`
-- ----------------------------
DROP TABLE IF EXISTS `t_bank_card`;
CREATE TABLE `t_bank_card` (
  `bank_card_id` int(11) NOT NULL AUTO_INCREMENT,
  `bank_card_user_id` int(11) NOT NULL,
  `bank_card_number` varchar(20) NOT NULL,
  `bank_card_pwd` varchar(20) NOT NULL DEFAULT '123456',
  `bank_card_balance` float(11,0) DEFAULT '1000',
  PRIMARY KEY (`bank_card_id`),
  KEY `fk_card_userId` (`bank_card_user_id`),
  CONSTRAINT `fk_card_userId` FOREIGN KEY (`bank_card_user_id`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_bank_card`
-- ----------------------------
BEGIN;
INSERT INTO `t_bank_card` VALUES ('4', '12', '8496010300848608', '123456', '962'), ('5', '13', '9447775724852988', '123456', '972'), ('6', '5', '7217432177473271', '123456', '508');
COMMIT;

-- ----------------------------
--  Table structure for `t_collect`
-- ----------------------------
DROP TABLE IF EXISTS `t_collect`;
CREATE TABLE `t_collect` (
  `collect_id` int(11) NOT NULL AUTO_INCREMENT,
  `collect_postId` int(11) NOT NULL,
  `collect_postUserId` int(11) NOT NULL,
  `collect_userId` int(11) NOT NULL,
  `collectCreate_time` date DEFAULT NULL,
  PRIMARY KEY (`collect_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_collect`
-- ----------------------------
BEGIN;
INSERT INTO `t_collect` VALUES ('2', '14', '6', '5', '2020-05-12'), ('3', '1', '3', '5', '2020-05-12'), ('5', '17', '5', '5', '2020-05-13');
COMMIT;

-- ----------------------------
--  Table structure for `t_deletion`
-- ----------------------------
DROP TABLE IF EXISTS `t_deletion`;
CREATE TABLE `t_deletion` (
  `deletion_id` int(11) NOT NULL AUTO_INCREMENT,
  `deletion_postTitle` varchar(20) NOT NULL,
  `deletion_postContent` varchar(100) NOT NULL,
  `deletion_remark` varchar(20) DEFAULT NULL,
  `deletionCreate_time` date DEFAULT NULL,
  `deletion_postUserId` int(11) NOT NULL,
  PRIMARY KEY (`deletion_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `t_like`
-- ----------------------------
DROP TABLE IF EXISTS `t_like`;
CREATE TABLE `t_like` (
  `like_id` int(11) NOT NULL AUTO_INCREMENT,
  `like_postId` int(11) NOT NULL,
  `like_postUserId` int(11) NOT NULL,
  `like_replyId` int(11) NOT NULL,
  `like_fromLikeUserId` int(11) NOT NULL,
  `like_byLikeUserId` int(11) NOT NULL,
  `likeCreate_time` date DEFAULT NULL,
  PRIMARY KEY (`like_id`),
  KEY `fk_like_postId` (`like_postId`),
  KEY `fk_like_userId` (`like_postUserId`),
  KEY `fk_like_replyId` (`like_replyId`),
  KEY `fk_like_fromUserId` (`like_fromLikeUserId`),
  KEY `fk_like_byUserId` (`like_byLikeUserId`),
  CONSTRAINT `fk_like_byUserId` FOREIGN KEY (`like_byLikeUserId`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_like_fromUserId` FOREIGN KEY (`like_fromLikeUserId`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_like_postId` FOREIGN KEY (`like_postId`) REFERENCES `t_post` (`post_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_like_replyId` FOREIGN KEY (`like_replyId`) REFERENCES `t_reply` (`reply_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_like_userId` FOREIGN KEY (`like_postUserId`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_like`
-- ----------------------------
BEGIN;
INSERT INTO `t_like` VALUES ('5', '13', '5', '1', '5', '6', '2020-05-13'), ('17', '13', '5', '7', '5', '12', '2020-05-15'), ('20', '20', '13', '14', '13', '5', '2020-05-15');
COMMIT;

-- ----------------------------
--  Table structure for `t_message`
-- ----------------------------
DROP TABLE IF EXISTS `t_message`;
CREATE TABLE `t_message` (
  `msg_id` int(11) NOT NULL AUTO_INCREMENT,
  `msg_fromUserId` int(11) DEFAULT NULL,
  `msg_byUserId` int(11) DEFAULT NULL,
  `msg_name` varchar(20) NOT NULL,
  `msg_content` varchar(50) DEFAULT NULL,
  `msg_status` enum('未阅读','已阅读') NOT NULL DEFAULT '未阅读',
  `msgCreate_time` date DEFAULT NULL,
  PRIMARY KEY (`msg_id`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_message`
-- ----------------------------
BEGIN;
INSERT INTO `t_message` VALUES ('1', '5', '3', '回复', '我是name5啊啊 啊啊', '未阅读', '2020-05-12'), ('3', '5', '3', '收藏', null, '未阅读', '2020-05-12'), ('4', '3', '5', '回复', '我是name333333333', '未阅读', '2020-05-12'), ('5', '5', '6', '点赞', null, '未阅读', '2020-05-13'), ('6', '5', '3', '点赞', null, '未阅读', '2020-05-13'), ('7', '5', '5', '收藏', null, '未阅读', '2020-05-13'), ('8', '5', '5', '收藏', null, '未阅读', '2020-05-13'), ('9', '5', '5', '收藏', null, '未阅读', '2020-05-13'), ('10', '5', '6', '点赞', null, '未阅读', '2020-05-13'), ('11', '5', '3', '收藏', null, '未阅读', '2020-05-14'), ('12', '5', '3', '收藏', null, '未阅读', '2020-05-14'), ('13', '5', '3', '收藏', null, '未阅读', '2020-05-14'), ('14', '5', '3', '收藏', null, '未阅读', '2020-05-14'), ('15', '5', '3', '收藏', null, '未阅读', '2020-05-14'), ('16', '5', '3', '收藏', null, '未阅读', '2020-05-14'), ('17', '5', '3', '收藏', null, '未阅读', '2020-05-14'), ('18', '5', '3', '收藏', null, '未阅读', '2020-05-14'), ('19', '5', '3', '收藏', null, '未阅读', '2020-05-14'), ('20', '5', '3', '收藏', null, '未阅读', '2020-05-14'), ('21', '5', '6', '点赞', null, '未阅读', '2020-05-14'), ('22', '5', '6', '点赞', null, '未阅读', '2020-05-14'), ('23', '5', '6', '点赞', null, '未阅读', '2020-05-14'), ('24', '5', '6', '点赞', null, '未阅读', '2020-05-14'), ('25', '5', '3', '点赞', null, '未阅读', '2020-05-14'), ('26', '5', '3', '点赞', null, '未阅读', '2020-05-14'), ('27', '5', '5', '收藏', null, '未阅读', '2020-05-14'), ('28', '5', '5', '收藏', null, '未阅读', '2020-05-14'), ('29', '5', '5', '回复', '我是5号。。。', '未阅读', '2020-05-14'), ('30', '12', '3', '回复', 'name3，你真有趣', '未阅读', '2020-05-14'), ('31', '12', '6', '回复', '围困住', '未阅读', '2020-05-14'), ('32', '12', '5', '点赞', null, '未阅读', '2020-05-15'), ('33', '12', '5', '点赞', null, '未阅读', '2020-05-15'), ('34', '12', '5', '点赞', null, '未阅读', '2020-05-15'), ('35', '12', '5', '点赞', null, '未阅读', '2020-05-15'), ('36', '12', '6', '点赞', null, '未阅读', '2020-05-15'), ('37', '12', '6', '点赞', null, '未阅读', '2020-05-15'), ('38', '12', '6', '点赞', null, '未阅读', '2020-05-15'), ('39', '12', '6', '点赞', null, '未阅读', '2020-05-15'), ('40', '12', '5', '点赞', null, '未阅读', '2020-05-15'), ('41', '12', '5', '点赞', null, '未阅读', '2020-05-15'), ('42', '5', '3', '点赞', null, '未阅读', '2020-05-15'), ('43', '5', '3', '点赞', null, '未阅读', '2020-05-15'), ('44', '5', '12', '点赞', null, '未阅读', '2020-05-15'), ('45', '5', '3', '点赞', null, '未阅读', '2020-05-15'), ('46', '5', '6', '点赞', null, '未阅读', '2020-05-15'), ('47', '5', '12', '点赞', null, '未阅读', '2020-05-15'), ('48', '5', '12', '点赞', null, '未阅读', '2020-05-15'), ('49', '5', '3', '点赞', null, '未阅读', '2020-05-15'), ('50', '5', '3', '点赞', null, '未阅读', '2020-05-15'), ('51', '4', '4', '回复', '你好，欢迎~', '未阅读', '2020-05-15'), ('52', '4', '4', '回复', '你好，111111', '未阅读', '2020-05-15'), ('53', '4', '4', '回复', '我是aaaaabbbb', '未阅读', '2020-05-15'), ('54', '13', '6', '回复', 'dfsfa', '未阅读', '2020-05-15'), ('55', '5', '13', '回复', '123123', '未阅读', '2020-05-15'), ('56', '5', '13', '回复', '3213', '未阅读', '2020-05-15'), ('57', '13', '5', '点赞', null, '未阅读', '2020-05-15');
COMMIT;

-- ----------------------------
--  Table structure for `t_post`
-- ----------------------------
DROP TABLE IF EXISTS `t_post`;
CREATE TABLE `t_post` (
  `post_id` int(11) NOT NULL AUTO_INCREMENT,
  `post_user_id` int(11) NOT NULL,
  `post_title` varchar(50) NOT NULL,
  `post_content` varchar(255) NOT NULL,
  `post_tab_id` int(11) DEFAULT NULL,
  `post_reward` int(11) DEFAULT '0',
  `post_status` varchar(11) DEFAULT '未结贴',
  `post_stick` varchar(11) DEFAULT '未置顶',
  `post_browse` int(11) NOT NULL DEFAULT '0' COMMENT '浏览量',
  `post_reply` int(11) NOT NULL DEFAULT '0',
  `post_collect` int(11) NOT NULL DEFAULT '0',
  `post_create_time` date DEFAULT NULL,
  `post_update_time` date DEFAULT NULL,
  PRIMARY KEY (`post_id`),
  KEY `fk_tab_id` (`post_tab_id`),
  KEY `fk_user_id` (`post_user_id`),
  CONSTRAINT `fk_tab_id` FOREIGN KEY (`post_tab_id`) REFERENCES `t_tab` (`tab_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_user_id` FOREIGN KEY (`post_user_id`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_post`
-- ----------------------------
BEGIN;
INSERT INTO `t_post` VALUES ('13', '5', '555', '6666666', '1', '50', '未结贴', '未置顶', '89', '5', '0', '2020-05-11', '2020-05-11'), ('14', '6', '666', '2222', '1', '5', '已结贴', '未置顶', '92', '0', '0', '2020-05-11', '2020-05-11'), ('15', '3', '如何学好Java', '有没有人一起学习Java。。。', '2', '5', '未结贴', '未置顶', '5', '0', '0', '2020-05-12', '2020-05-12'), ('16', '3', '我是333号', '你好呀 很高兴和大家一起讨论~', '3', '5', '未结贴', '未置顶', '23', '0', '0', '2020-05-12', '2020-05-12'), ('17', '5', '55577777', '5555777777啊啊', '2', '5', '未结贴', '未置顶', '18', '0', '0', '2020-05-13', '2020-05-13'), ('18', '6', '今天刚更新了系统，来说说看我的体验~', '续航较之前好多了~', '1', '5', '未结贴', '未置顶', '9', '1', '0', '2020-05-14', '2020-05-14'), ('19', '13', '大家好，aaaaaaa', 'dddddadafdsafdsa', '1', '5', '未结贴', '未置顶', '4', '1', '0', '2020-05-15', '2020-05-15'), ('20', '13', '我是随便，bbbbbbbbb', 'bbbbbbbbbb', '2', '5', '已结贴', '未置顶', '15', '3', '0', '2020-05-15', '2020-05-15'), ('21', '13', '123123', '123123123', '2', '5', '未结贴', '未置顶', '3', '1', '0', '2020-05-15', '2020-05-15');
COMMIT;

-- ----------------------------
--  Table structure for `t_reply`
-- ----------------------------
DROP TABLE IF EXISTS `t_reply`;
CREATE TABLE `t_reply` (
  `reply_id` int(11) NOT NULL AUTO_INCREMENT,
  `reply_postId` int(11) NOT NULL,
  `reply_postUserId` int(11) NOT NULL,
  `reply_fromReplyUserId` int(11) NOT NULL,
  `reply_byReplyUserId` int(11) NOT NULL,
  `reply_like` int(11) NOT NULL DEFAULT '0',
  `reply_content` varchar(255) NOT NULL,
  `reply_status` enum('普通回帖','最佳答案') DEFAULT '普通回帖',
  `reply_create_time` date DEFAULT NULL,
  PRIMARY KEY (`reply_id`),
  KEY `fk_reply_user3` (`reply_postUserId`),
  CONSTRAINT `fk_reply_user` FOREIGN KEY (`reply_postUserId`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_reply_user2` FOREIGN KEY (`reply_postUserId`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_reply_user3` FOREIGN KEY (`reply_postUserId`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_reply`
-- ----------------------------
BEGIN;
INSERT INTO `t_reply` VALUES ('1', '13', '5', '6', '5', '1', '222222', '普通回帖', '2020-05-11'), ('2', '14', '6', '6', '6', '0', '我是66666', '普通回帖', '2020-05-12'), ('3', '14', '6', '5', '6', '1', '我是name5', '最佳答案', '2020-05-12'), ('4', '1', '3', '5', '3', '0', '我是name5啊啊 啊啊', '普通回帖', '2020-05-12'), ('5', '13', '5', '3', '5', '0', '我是name333333333', '普通回帖', '2020-05-12'), ('6', '13', '5', '5', '5', '0', '我是5号。。。', '普通回帖', '2020-05-14'), ('7', '13', '5', '12', '3', '1', 'name3，你真有趣', '普通回帖', '2020-05-14'), ('8', '13', '5', '12', '6', '0', '围困住', '普通回帖', '2020-05-14'), ('11', '19', '13', '4', '4', '0', '我是aaaaabbbb', '普通回帖', '2020-05-15'), ('12', '18', '6', '13', '6', '0', 'dfsfa', '普通回帖', '2020-05-15'), ('13', '20', '13', '5', '13', '0', '123123', '普通回帖', '2020-05-15'), ('14', '20', '13', '5', '13', '1', '3213', '最佳答案', '2020-05-15');
COMMIT;

-- ----------------------------
--  Table structure for `t_report`
-- ----------------------------
DROP TABLE IF EXISTS `t_report`;
CREATE TABLE `t_report` (
  `report_id` int(11) NOT NULL AUTO_INCREMENT,
  `report_postId` int(11) NOT NULL,
  `report_postUserId` int(11) NOT NULL,
  `report_reportUserId` int(11) NOT NULL,
  `report_title` varchar(20) NOT NULL,
  `report_account` varchar(50) NOT NULL,
  `report_status` enum('未审核','已审核') NOT NULL DEFAULT '未审核',
  `reportCreate_time` date DEFAULT NULL,
  PRIMARY KEY (`report_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_report`
-- ----------------------------
BEGIN;
INSERT INTO `t_report` VALUES ('1', '14', '6', '5', '666', '我要举报', '未审核', '2020-05-12'), ('2', '16', '3', '5', '我是333号', '我要举报', '未审核', '2020-05-13'), ('3', '12', '3', '5', 'title333', '我要举报', '未审核', '2020-05-13'), ('5', '1', '3', '6', '标题33', '我要举报', '未审核', '2020-05-14'), ('6', '19', '13', '4', '大家好，aaaaaaa', '我要举报', '未审核', '2020-05-15');
COMMIT;

-- ----------------------------
--  Table structure for `t_right`
-- ----------------------------
DROP TABLE IF EXISTS `t_right`;
CREATE TABLE `t_right` (
  `right_id` int(11) NOT NULL AUTO_INCREMENT,
  `right_role_id` int(11) NOT NULL DEFAULT '1',
  `right_user_id` int(11) NOT NULL,
  PRIMARY KEY (`right_id`),
  KEY `fk_right_userId` (`right_user_id`),
  KEY `fk_right_roleId` (`right_role_id`),
  CONSTRAINT `fk_right_roleId` FOREIGN KEY (`right_role_id`) REFERENCES `t_role` (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_right_userId` FOREIGN KEY (`right_user_id`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_right`
-- ----------------------------
BEGIN;
INSERT INTO `t_right` VALUES ('1', '1', '3'), ('2', '0', '4'), ('3', '2', '5'), ('4', '1', '6'), ('6', '1', '8'), ('9', '2', '12'), ('10', '2', '13');
COMMIT;

-- ----------------------------
--  Table structure for `t_role`
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(20) NOT NULL DEFAULT '普通用户',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_role`
-- ----------------------------
BEGIN;
INSERT INTO `t_role` VALUES ('0', '管理员'), ('1', '普通用户'), ('2', '会员');
COMMIT;

-- ----------------------------
--  Table structure for `t_tab`
-- ----------------------------
DROP TABLE IF EXISTS `t_tab`;
CREATE TABLE `t_tab` (
  `tab_id` int(11) NOT NULL AUTO_INCREMENT,
  `tab_name` varchar(20) NOT NULL,
  PRIMARY KEY (`tab_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_tab`
-- ----------------------------
BEGIN;
INSERT INTO `t_tab` VALUES ('1', '互联网'), ('2', 'Java'), ('3', 'C语言'), ('4', '生活');
COMMIT;

-- ----------------------------
--  Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_email` varchar(20) NOT NULL,
  `user_name` varchar(20) NOT NULL,
  `user_pwd` varchar(20) NOT NULL,
  `user_sex` enum('男','女') NOT NULL DEFAULT '男',
  `user_city` varchar(20) DEFAULT NULL,
  `user_avatar` varchar(20) DEFAULT NULL,
  `user_motto` varchar(50) DEFAULT NULL,
  `user_money` float DEFAULT '100',
  `user_status` enum('正常','禁用') DEFAULT '正常',
  `user_create_time` date DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_user`
-- ----------------------------
BEGIN;
INSERT INTO `t_user` VALUES ('3', '625372291@qq.com', 'name3', '123456', '男', '南京', null, null, '90', null, '2020-04-29'), ('4', '123@qq.com', 'name4', '123456', '男', '深圳', null, '123123333', '100', null, '2020-04-29'), ('5', '5', 'name5', '5', '男', '深圳', null, '', '95', '正常', null), ('6', '6', 'name6', '6', '男', null, null, null, '90', '正常', null), ('7', '7@qq.com', '7', '7', '女', null, null, null, '100', null, '2020-05-12'), ('8', '8@qq.com', 'name88', '8', '男', null, null, null, '100', null, '2020-05-14'), ('12', '12@qq.com', '12', '12', '男', null, null, null, '300', null, '2020-05-14'), ('13', '1194111521@qq.com', '随便', '123456', '男', null, null, null, '185', null, '2020-05-15');
COMMIT;

-- ----------------------------
--  Table structure for `t_violation`
-- ----------------------------
DROP TABLE IF EXISTS `t_violation`;
CREATE TABLE `t_violation` (
  `violation_id` int(11) NOT NULL AUTO_INCREMENT,
  `violation_userId` int(11) NOT NULL,
  `violation_times` int(11) NOT NULL,
  PRIMARY KEY (`violation_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `t_vip`
-- ----------------------------
DROP TABLE IF EXISTS `t_vip`;
CREATE TABLE `t_vip` (
  `vip_id` int(11) NOT NULL AUTO_INCREMENT,
  `vip_userId` int(11) NOT NULL,
  `vipStart_time` date NOT NULL,
  `vipEnd_time` date NOT NULL,
  PRIMARY KEY (`vip_id`),
  KEY `fk_vip_userId` (`vip_userId`),
  CONSTRAINT `fk_vip_userId` FOREIGN KEY (`vip_userId`) REFERENCES `t_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `t_vip`
-- ----------------------------
BEGIN;
INSERT INTO `t_vip` VALUES ('2', '12', '2020-05-15', '2020-06-15'), ('3', '13', '2020-05-15', '2020-06-15'), ('25', '5', '2020-06-04', '2020-07-04');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
